Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 26148 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 10.0 MiB |
| Average record size in memory | 401.5 B |
Variable types
| NUM | 12 |
|---|---|
| CAT | 8 |
Reproduction
| Analysis started | 2022-12-10 15:39:12.572827 |
|---|---|
| Analysis finished | 2022-12-10 15:39:45.121895 |
| Duration | 32.55 seconds |
| Version | pandas-profiling v2.7.1 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Year has constant value "2016" | Constant |
Data has a high cardinality: 118 distinct values | High cardinality |
Time has a high cardinality: 7675 distinct values | High cardinality |
TimeSunRise has a high cardinality: 51 distinct values | High cardinality |
TimeSunSet has a high cardinality: 56 distinct values | High cardinality |
SunPerDay has a high cardinality: 75 distinct values | High cardinality |
Month is highly correlated with Id and 1 other fields | High correlation |
Id is highly correlated with Month | High correlation |
UNIXTime is highly correlated with Month | High correlation |
Month is highly correlated with TimeSunRise and 1 other fields | High correlation |
TimeSunRise is highly correlated with Month and 1 other fields | High correlation |
SunPerDay is highly correlated with TimeSunSet and 2 other fields | High correlation |
TimeSunSet is highly correlated with SunPerDay and 1 other fields | High correlation |
SunPerDayHours is highly correlated with TimeSunRise and 2 other fields | High correlation |
Id is uniformly distributed | Uniform |
Id has unique values | Unique |
UNIXTime has unique values | Unique |
Speed has 375 (1.4%) zeros | Zeros |
Hour has 1003 (3.8%) zeros | Zeros |
Minute has 2158 (8.3%) zeros | Zeros |
| Distinct count | 26148 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16337.57866758452 |
|---|---|
| Minimum | 0 |
| Maximum | 32685 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1608.35 |
| Q1 | 8125.75 |
| median | 16379 |
| Q3 | 24507.25 |
| 95-th percentile | 31048.65 |
| Maximum | 32685 |
| Range | 32685 |
| Interquartile range (IQR) | 16381.5 |
Descriptive statistics
| Standard deviation | 9449.975676 |
|---|---|
| Coefficient of variation (CV) | 0.5784195974 |
| Kurtosis | -1.202139245 |
| Mean | 16337.57867 |
| Median Absolute Deviation (MAD) | 8190.5 |
| Skewness | -0.002733428249 |
| Sum | 427195007 |
| Variance | 89302040.28 |
| Value | Count | Frequency (%) | |
| 4152 | 1 | < 0.1% | |
| 32190 | 1 | < 0.1% | |
| 10875 | 1 | < 0.1% | |
| 11572 | 1 | < 0.1% | |
| 739 | 1 | < 0.1% | |
| 1545 | 1 | < 0.1% | |
| 9327 | 1 | < 0.1% | |
| 5127 | 1 | < 0.1% | |
| 24546 | 1 | < 0.1% | |
| 23004 | 1 | < 0.1% | |
| Other values (26138) | 26138 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 32685 | 1 | < 0.1% | |
| 32684 | 1 | < 0.1% | |
| 32682 | 1 | < 0.1% | |
| 32681 | 1 | < 0.1% | |
| 32680 | 1 | < 0.1% |
| Distinct count | 26148 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1478046152.704528 |
|---|---|
| Minimum | 1472724008 |
| Maximum | 1483264501 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 1472724008 |
|---|---|
| 5-th percentile | 1473229431 |
| Q1 | 1475532770 |
| median | 1478038068 |
| Q3 | 1480478477 |
| 95-th percentile | 1482765838 |
| Maximum | 1483264501 |
| Range | 10540493 |
| Interquartile range (IQR) | 4945706.5 |
Descriptive statistics
| Standard deviation | 3005884.635 |
|---|---|
| Coefficient of variation (CV) | 0.00203368794 |
| Kurtosis | -1.142572373 |
| Mean | 1478046153 |
| Median Absolute Deviation (MAD) | 2501998.5 |
| Skewness | 0.006375119015 |
| Sum | 3.86479508e+13 |
| Variance | 9.035342439e+12 |
| Value | Count | Frequency (%) | |
| 1473879005 | 1 | < 0.1% | |
| 1480734907 | 1 | < 0.1% | |
| 1476954020 | 1 | < 0.1% | |
| 1476744921 | 1 | < 0.1% | |
| 1475004321 | 1 | < 0.1% | |
| 1474752322 | 1 | < 0.1% | |
| 1477419918 | 1 | < 0.1% | |
| 1473579921 | 1 | < 0.1% | |
| 1483257301 | 1 | < 0.1% | |
| 1478451005 | 1 | < 0.1% | |
| Other values (26138) | 26138 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1472724008 | 1 | < 0.1% | |
| 1472724310 | 1 | < 0.1% | |
| 1472725505 | 1 | < 0.1% | |
| 1472725809 | 1 | < 0.1% | |
| 1472726704 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1483264501 | 1 | < 0.1% | |
| 1483264203 | 1 | < 0.1% | |
| 1483263904 | 1 | < 0.1% | |
| 1483263601 | 1 | < 0.1% | |
| 1483263302 | 1 | < 0.1% |
| Distinct count | 118 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 204.4 KiB |
| 9/23/2016 12:00:00 AM | 245 |
|---|---|
| 10/27/2016 12:00:00 AM | 243 |
| 11/18/2016 12:00:00 AM | 242 |
| 11/3/2016 12:00:00 AM | 241 |
| 11/19/2016 12:00:00 AM | 240 |
| Other values (113) |
| Value | Count | Frequency (%) | |
| 9/23/2016 12:00:00 AM | 245 | 0.9% | |
| 10/27/2016 12:00:00 AM | 243 | 0.9% | |
| 11/18/2016 12:00:00 AM | 242 | 0.9% | |
| 11/3/2016 12:00:00 AM | 241 | 0.9% | |
| 11/19/2016 12:00:00 AM | 240 | 0.9% | |
| 12/16/2016 12:00:00 AM | 239 | 0.9% | |
| 12/23/2016 12:00:00 AM | 239 | 0.9% | |
| 12/19/2016 12:00:00 AM | 239 | 0.9% | |
| 12/2/2016 12:00:00 AM | 238 | 0.9% | |
| 9/29/2016 12:00:00 AM | 238 | 0.9% | |
| Other values (108) | 23744 | 90.8% |
Length
| Max length | 22 |
|---|---|
| Mean length | 21.49395747 |
| Min length | 20 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 66.7% | |
| Other_Punctuation | 2 | 13.3% | |
| Uppercase_Letter | 2 | 13.3% | |
| Space_Separator | 1 | 6.7% |
| Value | Count | Frequency (%) | |
| Common | 13 | 86.7% | |
| Latin | 2 | 13.3% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 7675 |
|---|---|
| Unique (%) | 29.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 204.4 KiB |
| 02:05:02 | 18 |
|---|---|
| 06:05:18 | 18 |
| 12:25:18 | 17 |
| 09:05:18 | 17 |
| 03:45:18 | 17 |
| Other values (7670) |
| Value | Count | Frequency (%) | |
| 02:05:02 | 18 | 0.1% | |
| 06:05:18 | 18 | 0.1% | |
| 12:25:18 | 17 | 0.1% | |
| 09:05:18 | 17 | 0.1% | |
| 03:45:18 | 17 | 0.1% | |
| 12:45:18 | 17 | 0.1% | |
| 20:05:18 | 17 | 0.1% | |
| 08:30:18 | 16 | 0.1% | |
| 20:35:18 | 16 | 0.1% | |
| 14:55:18 | 16 | 0.1% | |
| Other values (7665) | 25979 | 99.4% |
Length
| Max length | 8 |
|---|---|
| Mean length | 8 |
| Min length | 8 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 90.9% | |
| Other_Punctuation | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Common | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
Temperature
Real number (ℝ≥0)
| Distinct count | 38 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.1048646167967 |
|---|---|
| Minimum | 34 |
| Maximum | 71 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 34 |
|---|---|
| 5-th percentile | 43 |
| Q1 | 46 |
| median | 50 |
| Q3 | 55 |
| 95-th percentile | 63 |
| Maximum | 71 |
| Range | 37 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 6.213912409 |
|---|---|
| Coefficient of variation (CV) | 0.1215914073 |
| Kurtosis | -0.3191962441 |
| Mean | 51.10486462 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.5176414002 |
| Sum | 1336290 |
| Variance | 38.61270743 |
| Value | Count | Frequency (%) | |
| 45 | 2358 | 9.0% | |
| 48 | 2085 | 8.0% | |
| 47 | 2027 | 7.8% | |
| 46 | 1706 | 6.5% | |
| 50 | 1658 | 6.3% | |
| 49 | 1610 | 6.2% | |
| 51 | 1543 | 5.9% | |
| 52 | 1218 | 4.7% | |
| 53 | 1071 | 4.1% | |
| 54 | 1011 | 3.9% | |
| Other values (28) | 9861 | 37.7% |
| Value | Count | Frequency (%) | |
| 34 | 1 | < 0.1% | |
| 35 | 7 | < 0.1% | |
| 36 | 36 | 0.1% | |
| 37 | 79 | 0.3% | |
| 38 | 81 | 0.3% |
| Value | Count | Frequency (%) | |
| 71 | 13 | < 0.1% | |
| 70 | 33 | 0.1% | |
| 69 | 30 | 0.1% | |
| 68 | 44 | 0.2% | |
| 67 | 69 | 0.3% |
Pressure
Real number (ℝ≥0)
| Distinct count | 38 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.42283501606241 |
|---|---|
| Minimum | 30.19 |
| Maximum | 30.56 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 30.19 |
|---|---|
| 5-th percentile | 30.3 |
| Q1 | 30.4 |
| median | 30.43 |
| Q3 | 30.46 |
| 95-th percentile | 30.49 |
| Maximum | 30.56 |
| Range | 0.37 |
| Interquartile range (IQR) | 0.06 |
Descriptive statistics
| Standard deviation | 0.05472382402 |
|---|---|
| Coefficient of variation (CV) | 0.001798774637 |
| Kurtosis | 2.119855824 |
| Mean | 30.42283502 |
| Median Absolute Deviation (MAD) | 0.03 |
| Skewness | -1.235212722 |
| Sum | 795496.29 |
| Variance | 0.002994696916 |
| Value | Count | Frequency (%) | |
| 30.44 | 2652 | 10.1% | |
| 30.43 | 2525 | 9.7% | |
| 30.45 | 2449 | 9.4% | |
| 30.42 | 2304 | 8.8% | |
| 30.46 | 2164 | 8.3% | |
| 30.41 | 1872 | 7.2% | |
| 30.47 | 1837 | 7.0% | |
| 30.4 | 1593 | 6.1% | |
| 30.48 | 1299 | 5.0% | |
| 30.39 | 1183 | 4.5% | |
| Other values (28) | 6270 | 24.0% |
| Value | Count | Frequency (%) | |
| 30.19 | 13 | < 0.1% | |
| 30.2 | 33 | 0.1% | |
| 30.21 | 39 | 0.1% | |
| 30.22 | 36 | 0.1% | |
| 30.23 | 65 | 0.2% |
| Value | Count | Frequency (%) | |
| 30.56 | 26 | 0.1% | |
| 30.55 | 23 | 0.1% | |
| 30.54 | 65 | 0.2% | |
| 30.53 | 43 | 0.2% | |
| 30.52 | 151 | 0.6% |
Humidity
Real number (ℝ≥0)
| Distinct count | 93 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 75.00523940645556 |
|---|---|
| Minimum | 11 |
| Maximum | 103 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 56 |
| median | 85 |
| Q3 | 97 |
| 95-th percentile | 102 |
| Maximum | 103 |
| Range | 92 |
| Interquartile range (IQR) | 41 |
Descriptive statistics
| Standard deviation | 25.9931019 |
|---|---|
| Coefficient of variation (CV) | 0.3465504824 |
| Kurtosis | -0.7543674338 |
| Mean | 75.00523941 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | -0.7746688274 |
| Sum | 1961237 |
| Variance | 675.6413463 |
| Value | Count | Frequency (%) | |
| 102 | 1690 | 6.5% | |
| 101 | 1591 | 6.1% | |
| 93 | 1437 | 5.5% | |
| 100 | 1218 | 4.7% | |
| 99 | 969 | 3.7% | |
| 98 | 757 | 2.9% | |
| 97 | 643 | 2.5% | |
| 96 | 594 | 2.3% | |
| 95 | 560 | 2.1% | |
| 94 | 483 | 1.8% | |
| Other values (83) | 16206 | 62.0% |
| Value | Count | Frequency (%) | |
| 11 | 4 | < 0.1% | |
| 12 | 11 | < 0.1% | |
| 13 | 36 | 0.1% | |
| 14 | 36 | 0.1% | |
| 15 | 61 | 0.2% |
| Value | Count | Frequency (%) | |
| 103 | 170 | 0.7% | |
| 102 | 1690 | 6.5% | |
| 101 | 1591 | 6.1% | |
| 100 | 1218 | 4.7% | |
| 99 | 969 | 3.7% |
WindDirection(Degrees)
Real number (ℝ≥0)
| Distinct count | 15777 |
|---|---|
| Unique (%) | 60.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 143.25996978736424 |
|---|---|
| Minimum | 0.09 |
| Maximum | 359.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 0.09 |
|---|---|
| 5-th percentile | 16.937 |
| Q1 | 81.9775 |
| median | 147.645 |
| Q3 | 179.22 |
| 95-th percentile | 323.3665 |
| Maximum | 359.95 |
| Range | 359.86 |
| Interquartile range (IQR) | 97.2425 |
Descriptive statistics
| Standard deviation | 82.98817746 |
|---|---|
| Coefficient of variation (CV) | 0.5792837844 |
| Kurtosis | 0.2319634337 |
| Mean | 143.2599698 |
| Median Absolute Deviation (MAD) | 42.37 |
| Skewness | 0.5628664262 |
| Sum | 3745961.69 |
| Variance | 6887.037597 |
| Value | Count | Frequency (%) | |
| 0.11 | 76 | 0.3% | |
| 359.93 | 49 | 0.2% | |
| 359.92 | 39 | 0.1% | |
| 0.1 | 31 | 0.1% | |
| 0.12 | 29 | 0.1% | |
| 85.39 | 17 | 0.1% | |
| 191.13 | 12 | < 0.1% | |
| 359.91 | 12 | < 0.1% | |
| 25.99 | 12 | < 0.1% | |
| 177.56 | 12 | < 0.1% | |
| Other values (15767) | 25859 | 98.9% |
| Value | Count | Frequency (%) | |
| 0.09 | 2 | < 0.1% | |
| 0.1 | 31 | 0.1% | |
| 0.11 | 76 | 0.3% | |
| 0.12 | 29 | 0.1% | |
| 0.13 | 8 | < 0.1% |
| Value | Count | Frequency (%) | |
| 359.95 | 1 | < 0.1% | |
| 359.94 | 3 | < 0.1% | |
| 359.93 | 49 | 0.2% | |
| 359.92 | 39 | 0.1% | |
| 359.91 | 12 | < 0.1% |
| Distinct count | 36 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.248521493039621 |
|---|---|
| Minimum | 0.0 |
| Maximum | 39.37 |
| Zeros | 375 |
| Zeros (%) | 1.4% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.12 |
| Q1 | 3.37 |
| median | 5.62 |
| Q3 | 7.87 |
| 95-th percentile | 12.37 |
| Maximum | 39.37 |
| Range | 39.37 |
| Interquartile range (IQR) | 4.5 |
Descriptive statistics
| Standard deviation | 3.484165777 |
|---|---|
| Coefficient of variation (CV) | 0.5575984304 |
| Kurtosis | 6.910850573 |
| Mean | 6.248521493 |
| Median Absolute Deviation (MAD) | 2.25 |
| Skewness | 1.499486136 |
| Sum | 163386.34 |
| Variance | 12.13941116 |
| Value | Count | Frequency (%) | |
| 5.62 | 3680 | 14.1% | |
| 4.5 | 3612 | 13.8% | |
| 6.75 | 3482 | 13.3% | |
| 3.37 | 3093 | 11.8% | |
| 7.87 | 2858 | 10.9% | |
| 2.25 | 2201 | 8.4% | |
| 9 | 2035 | 7.8% | |
| 10.12 | 1374 | 5.3% | |
| 1.12 | 1102 | 4.2% | |
| 11.25 | 865 | 3.3% | |
| Other values (26) | 1846 | 7.1% |
| Value | Count | Frequency (%) | |
| 0 | 375 | 1.4% | |
| 1.12 | 1102 | 4.2% | |
| 2.25 | 2201 | 8.4% | |
| 3.37 | 3093 | 11.8% | |
| 4.5 | 3612 | 13.8% |
| Value | Count | Frequency (%) | |
| 39.37 | 1 | < 0.1% | |
| 38.25 | 2 | < 0.1% | |
| 37.12 | 2 | < 0.1% | |
| 36 | 3 | < 0.1% | |
| 34.87 | 3 | < 0.1% |
| Distinct count | 51 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 204.4 KiB |
| 06:11:00 | 1116 |
|---|---|
| 06:08:00 | 1065 |
| 06:10:00 | 924 |
| 06:13:00 | 921 |
| 06:12:00 | 912 |
| Other values (46) |
| Value | Count | Frequency (%) | |
| 06:11:00 | 1116 | 4.3% | |
| 06:08:00 | 1065 | 4.1% | |
| 06:10:00 | 924 | 3.5% | |
| 06:13:00 | 921 | 3.5% | |
| 06:12:00 | 912 | 3.5% | |
| 06:16:00 | 898 | 3.4% | |
| 06:14:00 | 889 | 3.4% | |
| 06:09:00 | 824 | 3.2% | |
| 06:56:00 | 690 | 2.6% | |
| 06:23:00 | 686 | 2.6% | |
| Other values (41) | 17223 | 65.9% |
Length
| Max length | 8 |
|---|---|
| Mean length | 8 |
| Min length | 8 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 90.9% | |
| Other_Punctuation | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Common | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
| Distinct count | 56 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 204.4 KiB |
| 17:42:00 | 2961 |
|---|---|
| 17:43:00 | 1829 |
| 17:44:00 | 1491 |
| 17:46:00 | 1391 |
| 17:45:00 | 1140 |
| Other values (51) |
| Value | Count | Frequency (%) | |
| 17:42:00 | 2961 | 11.3% | |
| 17:43:00 | 1829 | 7.0% | |
| 17:44:00 | 1491 | 5.7% | |
| 17:46:00 | 1391 | 5.3% | |
| 17:45:00 | 1140 | 4.4% | |
| 17:47:00 | 935 | 3.6% | |
| 17:51:00 | 925 | 3.5% | |
| 17:48:00 | 923 | 3.5% | |
| 17:49:00 | 911 | 3.5% | |
| 17:54:00 | 908 | 3.5% | |
| Other values (46) | 12734 | 48.7% |
Length
| Max length | 8 |
|---|---|
| Mean length | 8 |
| Min length | 8 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 90.9% | |
| Other_Punctuation | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Common | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
Radiation
Real number (ℝ≥0)
| Distinct count | 11826 |
|---|---|
| Unique (%) | 45.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 208.04478048034267 |
|---|---|
| Minimum | 1.13 |
| Maximum | 1601.26 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 1.13 |
|---|---|
| 5-th percentile | 1.19 |
| Q1 | 1.23 |
| median | 2.71 |
| Q3 | 358.945 |
| 95-th percentile | 905.965 |
| Maximum | 1601.26 |
| Range | 1600.13 |
| Interquartile range (IQR) | 357.715 |
Descriptive statistics
| Standard deviation | 316.0902472 |
|---|---|
| Coefficient of variation (CV) | 1.519337551 |
| Kurtosis | 0.4816721632 |
| Mean | 208.0447805 |
| Median Absolute Deviation (MAD) | 1.53 |
| Skewness | 1.358960261 |
| Sum | 5439954.92 |
| Variance | 99913.04436 |
| Value | Count | Frequency (%) | |
| 1.22 | 1751 | 6.7% | |
| 1.23 | 1692 | 6.5% | |
| 1.21 | 1623 | 6.2% | |
| 1.24 | 1357 | 5.2% | |
| 1.2 | 1247 | 4.8% | |
| 1.25 | 949 | 3.6% | |
| 1.19 | 773 | 3.0% | |
| 1.26 | 586 | 2.2% | |
| 1.18 | 385 | 1.5% | |
| 1.27 | 367 | 1.4% | |
| Other values (11816) | 15418 | 59.0% |
| Value | Count | Frequency (%) | |
| 1.13 | 3 | < 0.1% | |
| 1.14 | 4 | < 0.1% | |
| 1.15 | 35 | 0.1% | |
| 1.16 | 68 | 0.3% | |
| 1.17 | 176 | 0.7% |
| Value | Count | Frequency (%) | |
| 1601.26 | 1 | < 0.1% | |
| 1475.4 | 1 | < 0.1% | |
| 1451.41 | 1 | < 0.1% | |
| 1410.52 | 1 | < 0.1% | |
| 1387.17 | 1 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 204.4 KiB |
| 2016 |
|---|
| Value | Count | Frequency (%) | |
| 2016 | 26148 | 100.0% |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 4 | 100.0% |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 204.4 KiB |
| 10 | |
|---|---|
| 11 | |
| 12 | |
| 9 |
| Value | Count | Frequency (%) | |
| 10 | 6995 | 26.8% | |
| 11 | 6657 | 25.5% | |
| 12 | 6527 | 25.0% | |
| 9 | 5969 | 22.8% |
Length
| Max length | 2 |
|---|---|
| Mean length | 1.771722503 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 4 | 100.0% |
Day
Real number (ℝ≥0)
| Distinct count | 31 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.828935291418082 |
|---|---|
| Minimum | 1 |
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 9 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 8.706177276 |
|---|---|
| Coefficient of variation (CV) | 0.5500166066 |
| Kurtosis | -1.171341809 |
| Mean | 15.82893529 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -0.06613776473 |
| Sum | 413895 |
| Variance | 75.79752276 |
| Value | Count | Frequency (%) | |
| 23 | 947 | 3.6% | |
| 2 | 937 | 3.6% | |
| 22 | 931 | 3.6% | |
| 27 | 931 | 3.6% | |
| 19 | 929 | 3.6% | |
| 18 | 919 | 3.5% | |
| 14 | 915 | 3.5% | |
| 17 | 913 | 3.5% | |
| 3 | 913 | 3.5% | |
| 20 | 912 | 3.5% | |
| Other values (21) | 16901 | 64.6% |
| Value | Count | Frequency (%) | |
| 1 | 875 | 3.3% | |
| 2 | 937 | 3.6% | |
| 3 | 913 | 3.5% | |
| 4 | 908 | 3.5% | |
| 5 | 873 | 3.3% |
| Value | Count | Frequency (%) | |
| 31 | 436 | 1.7% | |
| 30 | 456 | 1.7% | |
| 29 | 886 | 3.4% | |
| 28 | 907 | 3.5% | |
| 27 | 931 | 3.6% |
| Distinct count | 24 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.523022793330274 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros | 1003 |
| Zeros (%) | 3.8% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 12 |
| Q3 | 18 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 6.917195806 |
|---|---|
| Coefficient of variation (CV) | 0.6002935107 |
| Kurtosis | -1.209506317 |
| Mean | 11.52302279 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.001670671384 |
| Sum | 301304 |
| Variance | 47.84759782 |
| Value | Count | Frequency (%) | |
| 13 | 1134 | 4.3% | |
| 2 | 1118 | 4.3% | |
| 4 | 1113 | 4.3% | |
| 3 | 1111 | 4.2% | |
| 22 | 1107 | 4.2% | |
| 1 | 1103 | 4.2% | |
| 6 | 1101 | 4.2% | |
| 14 | 1101 | 4.2% | |
| 20 | 1101 | 4.2% | |
| 8 | 1098 | 4.2% | |
| Other values (14) | 15061 | 57.6% |
| Value | Count | Frequency (%) | |
| 0 | 1003 | 3.8% | |
| 1 | 1103 | 4.2% | |
| 2 | 1118 | 4.3% | |
| 3 | 1111 | 4.2% | |
| 4 | 1113 | 4.3% |
| Value | Count | Frequency (%) | |
| 23 | 1094 | 4.2% | |
| 22 | 1107 | 4.2% | |
| 21 | 1083 | 4.1% | |
| 20 | 1101 | 4.2% | |
| 19 | 1096 | 4.2% |
| Distinct count | 26 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.522755086431086 |
|---|---|
| Minimum | 0 |
| Maximum | 57 |
| Zeros | 2158 |
| Zeros (%) | 8.3% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 15 |
| median | 30 |
| Q3 | 41 |
| 95-th percentile | 55 |
| Maximum | 57 |
| Range | 57 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 17.25434808 |
|---|---|
| Coefficient of variation (CV) | 0.626912096 |
| Kurtosis | -1.214326679 |
| Mean | 27.52275509 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | -0.002075381756 |
| Sum | 719665 |
| Variance | 297.7125277 |
| Value | Count | Frequency (%) | |
| 35 | 2194 | 8.4% | |
| 50 | 2165 | 8.3% | |
| 40 | 2161 | 8.3% | |
| 25 | 2159 | 8.3% | |
| 0 | 2158 | 8.3% | |
| 10 | 2156 | 8.2% | |
| 30 | 2143 | 8.2% | |
| 15 | 2140 | 8.2% | |
| 55 | 2139 | 8.2% | |
| 5 | 2132 | 8.2% | |
| Other values (16) | 4601 | 17.6% |
| Value | Count | Frequency (%) | |
| 0 | 2158 | 8.3% | |
| 1 | 29 | 0.1% | |
| 2 | 1 | < 0.1% | |
| 5 | 2132 | 8.2% | |
| 6 | 29 | 0.1% |
| Value | Count | Frequency (%) | |
| 57 | 3 | < 0.1% | |
| 56 | 30 | 0.1% | |
| 55 | 2139 | 8.2% | |
| 51 | 33 | 0.1% | |
| 50 | 2165 | 8.3% |
Second
Real number (ℝ≥0)
| Distinct count | 60 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.44752944775891 |
|---|---|
| Minimum | 0 |
| Maximum | 59 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Memory size | 204.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 18 |
| Q3 | 22 |
| 95-th percentile | 49 |
| Maximum | 59 |
| Range | 59 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 12.91335632 |
|---|---|
| Coefficient of variation (CV) | 0.7401252057 |
| Kurtosis | 0.557898701 |
| Mean | 17.44752945 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.8325560576 |
| Sum | 456218 |
| Variance | 166.7547715 |
| Value | Count | Frequency (%) | |
| 18 | 3040 | 11.6% | |
| 2 | 2603 | 10.0% | |
| 20 | 2131 | 8.1% | |
| 17 | 1838 | 7.0% | |
| 21 | 1714 | 6.6% | |
| 19 | 1362 | 5.2% | |
| 4 | 1357 | 5.2% | |
| 1 | 1325 | 5.1% | |
| 22 | 1152 | 4.4% | |
| 5 | 1116 | 4.3% | |
| Other values (50) | 8510 | 32.5% |
| Value | Count | Frequency (%) | |
| 0 | 2 | < 0.1% | |
| 1 | 1325 | 5.1% | |
| 2 | 2603 | 10.0% | |
| 3 | 945 | 3.6% | |
| 4 | 1357 | 5.2% |
| Value | Count | Frequency (%) | |
| 59 | 8 | < 0.1% | |
| 58 | 16 | 0.1% | |
| 57 | 16 | 0.1% | |
| 56 | 32 | 0.1% | |
| 55 | 44 | 0.2% |
| Distinct count | 75 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 204.4 KiB |
| 0 days 10:56:00 | 3242 |
|---|---|
| 0 days 10:57:00 | 1811 |
| 0 days 11:22:00 | 472 |
| 0 days 11:12:00 | 471 |
| 0 days 11:00:00 | 471 |
| Other values (70) |
| Value | Count | Frequency (%) | |
| 0 days 10:56:00 | 3242 | 12.4% | |
| 0 days 10:57:00 | 1811 | 6.9% | |
| 0 days 11:22:00 | 472 | 1.8% | |
| 0 days 11:12:00 | 471 | 1.8% | |
| 0 days 11:00:00 | 471 | 1.8% | |
| 0 days 11:04:00 | 470 | 1.8% | |
| 0 days 11:37:00 | 468 | 1.8% | |
| 0 days 11:34:00 | 468 | 1.8% | |
| 0 days 11:07:00 | 467 | 1.8% | |
| 0 days 11:08:00 | 467 | 1.8% | |
| Other values (65) | 17341 | 66.3% |
Length
| Max length | 15 |
|---|---|
| Mean length | 15 |
| Min length | 15 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 62.5% | |
| Lowercase_Letter | 4 | 25.0% | |
| Space_Separator | 1 | 6.2% | |
| Other_Punctuation | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| Common | 12 | 75.0% | |
| Latin | 4 | 25.0% |
| Value | Count | Frequency (%) | |
| ASCII | 16 | 100.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Id | UNIXTime | Data | Time | Temperature | Pressure | Humidity | WindDirection(Degrees) | Speed | TimeSunRise | TimeSunSet | Radiation | Year | Month | Day | Hour | Minute | Second | SunPerDay | SunPerDayHours | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 4152 | 1473879005 | 9/14/2016 12:00:00 AM | 08:50:05 | 57 | 30.45 | 68 | 26.70 | 4.50 | 06:10:00 | 18:26:00 | 680.04 | 2016 | 9 | 14 | 8 | 50 | 5 | 0 days 12:16:00 | 12 |
| 1 | 13047 | 1476293121 | 10/12/2016 12:00:00 AM | 07:25:21 | 50 | 30.47 | 96 | 144.96 | 10.12 | 06:16:00 | 18:02:00 | 277.37 | 2016 | 10 | 12 | 7 | 25 | 21 | 0 days 11:46:00 | 12 |
| 2 | 7420 | 1477993220 | 10/31/2016 12:00:00 AM | 23:40:20 | 47 | 30.48 | 56 | 119.52 | 3.37 | 06:23:00 | 17:49:00 | 1.29 | 2016 | 10 | 31 | 23 | 40 | 20 | 0 days 11:26:00 | 11 |
| 3 | 6508 | 1473013505 | 9/4/2016 12:00:00 AM | 08:25:05 | 57 | 30.47 | 93 | 38.61 | 2.25 | 06:08:00 | 18:35:00 | 544.75 | 2016 | 9 | 4 | 8 | 25 | 5 | 0 days 12:27:00 | 12 |
| 4 | 29110 | 1481885434 | 12/16/2016 12:00:00 AM | 00:50:34 | 41 | 30.23 | 103 | 177.55 | 2.25 | 06:50:00 | 17:46:00 | 1.22 | 2016 | 12 | 16 | 0 | 50 | 34 | 0 days 10:56:00 | 11 |
| 5 | 25348 | 1483015543 | 12/29/2016 12:00:00 AM | 02:45:43 | 37 | 30.35 | 54 | 177.00 | 6.75 | 06:56:00 | 17:53:00 | 1.15 | 2016 | 12 | 29 | 2 | 45 | 43 | 0 days 10:57:00 | 11 |
| 6 | 13599 | 1476124823 | 10/10/2016 12:00:00 AM | 08:40:23 | 60 | 30.44 | 47 | 4.88 | 1.12 | 06:16:00 | 18:03:00 | 578.60 | 2016 | 10 | 10 | 8 | 40 | 23 | 0 days 11:47:00 | 12 |
| 7 | 20795 | 1479113702 | 11/13/2016 12:00:00 AM | 22:55:02 | 45 | 30.47 | 83 | 114.39 | 6.75 | 06:30:00 | 17:44:00 | 1.20 | 2016 | 11 | 13 | 22 | 55 | 2 | 0 days 11:14:00 | 11 |
| 8 | 28143 | 1482176417 | 12/19/2016 12:00:00 AM | 09:40:17 | 53 | 30.53 | 84 | 154.09 | 7.87 | 06:52:00 | 17:48:00 | 269.53 | 2016 | 12 | 19 | 9 | 40 | 17 | 0 days 10:56:00 | 11 |
| 9 | 15824 | 1475442321 | 10/2/2016 12:00:00 AM | 11:05:21 | 57 | 30.47 | 99 | 40.61 | 1.12 | 06:14:00 | 18:10:00 | 942.25 | 2016 | 10 | 2 | 11 | 5 | 21 | 0 days 11:56:00 | 12 |
Last rows
| Id | UNIXTime | Data | Time | Temperature | Pressure | Humidity | WindDirection(Degrees) | Speed | TimeSunRise | TimeSunSet | Radiation | Year | Month | Day | Hour | Minute | Second | SunPerDay | SunPerDayHours | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26138 | 6265 | 1473089111 | 9/5/2016 12:00:00 AM | 05:25:11 | 47 | 30.40 | 73 | 179.01 | 7.87 | 06:08:00 | 18:35:00 | 2.69 | 2016 | 9 | 5 | 5 | 25 | 11 | 0 days 12:27:00 | 12 |
| 26139 | 22118 | 1478716805 | 11/9/2016 12:00:00 AM | 08:40:05 | 54 | 30.46 | 51 | 337.08 | 2.25 | 06:28:00 | 17:45:00 | 484.33 | 2016 | 11 | 9 | 8 | 40 | 5 | 0 days 11:17:00 | 11 |
| 26140 | 11284 | 1476831318 | 10/18/2016 12:00:00 AM | 12:55:18 | 58 | 30.41 | 98 | 350.19 | 9.00 | 06:18:00 | 17:57:00 | 556.69 | 2016 | 10 | 18 | 12 | 55 | 18 | 0 days 11:39:00 | 11 |
| 26141 | 11964 | 1476625223 | 10/16/2016 12:00:00 AM | 03:40:23 | 50 | 30.49 | 24 | 158.70 | 5.62 | 06:18:00 | 17:59:00 | 1.19 | 2016 | 10 | 16 | 3 | 40 | 23 | 0 days 11:41:00 | 11 |
| 26142 | 21575 | 1478879702 | 11/11/2016 12:00:00 AM | 05:55:02 | 46 | 30.47 | 36 | 180.23 | 6.75 | 06:29:00 | 17:44:00 | 1.23 | 2016 | 11 | 11 | 5 | 55 | 2 | 0 days 11:15:00 | 11 |
| 26143 | 29802 | 1481676309 | 12/13/2016 12:00:00 AM | 14:45:09 | 50 | 30.28 | 96 | 304.22 | 12.37 | 06:48:00 | 17:45:00 | 216.29 | 2016 | 12 | 13 | 14 | 45 | 9 | 0 days 10:57:00 | 11 |
| 26144 | 5390 | 1473426025 | 9/9/2016 12:00:00 AM | 03:00:25 | 44 | 30.37 | 100 | 162.80 | 3.37 | 06:09:00 | 18:31:00 | 1.47 | 2016 | 9 | 9 | 3 | 0 | 25 | 0 days 12:22:00 | 12 |
| 26145 | 860 | 1474966519 | 9/26/2016 12:00:00 AM | 22:55:19 | 48 | 30.42 | 64 | 158.90 | 4.50 | 06:12:00 | 18:15:00 | 1.20 | 2016 | 9 | 26 | 22 | 55 | 19 | 0 days 12:03:00 | 12 |
| 26146 | 15795 | 1475451021 | 10/2/2016 12:00:00 AM | 13:30:21 | 56 | 30.42 | 99 | 55.72 | 13.50 | 06:14:00 | 18:10:00 | 659.12 | 2016 | 10 | 2 | 13 | 30 | 21 | 0 days 11:56:00 | 12 |
| 26147 | 23654 | 1478255721 | 11/4/2016 12:00:00 AM | 00:35:21 | 45 | 30.45 | 56 | 136.11 | 5.62 | 06:25:00 | 17:47:00 | 1.18 | 2016 | 11 | 4 | 0 | 35 | 21 | 0 days 11:22:00 | 11 |